2012-11-27 - 5439.100 - Service Request - Add Two fields to SAP Planning #FICOSupport
5439.100 - Add Two fields to SAP Planning
Summary Description
Find two unused fields in GLPCT (or one of the other planning SAP tables – GLPCC, GLPCP, GLPCA) that can be populated with Silhouette and License.
Admin Info
Purpose
|
Add Two fields to SAP Planning
|
Requested by
|
Mike williams
|
Issue Date
|
11/27/2012
|
Resolved by
|
Sai Valisetti
|
Resolved Date
|
11/27/2012
|
Document Status
|
Complete
|
Detailed Description
(Include Screen Shots if required )
Find two unused fields in GLPCT (or one of the other planning SAP tables – GLPCC, GLPCP, GLPCA) that can be populated with Silhouette and License.
The two fields I thought we could use are not passed to BI (Functional Area and Origin Group) today. We want to try to use fields that are all ready going to BI so that they won’t have a lot of work to do (except change/create new reports). Mark did say if we wanted to use two fields that are not being passed today we could ask him if they could be passed easily…..
Financial Infocube - GLPC Plan Data ( Z_GLPCP )
|
Characteristics
|
Description
|
0ACCOUNT
|
Account Number
|
0ACTTYPE
|
Activity Type
|
0BILL_TYPE
|
Billing type
|
0CHRT_ACCTS
|
Chart of accounts
|
0COMP_CODE
|
Company code
|
0CO_AREA
|
Controlling area
|
0COSTCENTER
|
Cost Center
|
0CUSTOMER
|
Customer number
|
0FI_DBCRIND
|
Debit/Credit Indicator
|
0DISTR_CHAN
|
Distribution Channel
|
0DIVISION
|
Division
|
0DOC_DATE
|
Document Date
|
0AC_DOC_TYP
|
Document type
|
0GL_ACCOUNT
|
G/L Account
|
0MATERIAL
|
Material
|
0COORDER
|
Order number
|
0PART_PRCTR
|
Partner profit center
|
ZPERIOD
|
Period for GLPC Plan
|
0PLANT
|
Plant
|
0PSTNG_DATE
|
Posting date in the document
|
0PROFIT_CTR
|
Profit Center
|
0REF_DOC_NO
|
Reference document number
|
0SALES_OFF
|
Sales Office
|
0SALESORG
|
Sales Organization
|
0DOC_NUMBER
|
Sales document
|
0S_ORD_ITEM
|
Sales document item
|
0SALES_GRP
|
Sales group
|
0REC_TYPE
|
Transaction Type
|
0ID_VALAREA
|
Valuation Area
|
0VAL_TYPE
|
Valuation type
|
0VALUATION
|
Valuation view
|
0VENDOR
|
Vendor
|
0VERSION
|
Version
|
|
|
Key Figures
|
Description
|
Z_COCDCY
|
Amount in Comp Code Currency
|
Z_PRFTCY
|
Amount in Profit Center Local Currency
|
Z_TRANCY
|
Amount in Transaction Currency
|
|
|
Time Characteristics
|
Description
|
0FISCYEAR
|
Fiscal year
|
0FISCPER
|
Fiscal year / period
|
0FISCVARNT
|
Fiscal year variant
|
0FISCPER3
|
Posting period
|
|
|
Currency / Units
|
Description
|
0CURRENCY
|
Currency Key
|
Analysis and Recommendations
(Include Screen Shots if required)
Validated the request and suggester two fields for BI to use.
report KE5Y,GLPCP-SGTXT(Text field),
GLPCP-AWTYP(Reference Transaction)
Resolution
Release Information
Provide link here to Release Notes